#!/bin/sh

currDate=`date +%Y-%m-%d`

hive -e "USE default;INSERT INTO TABLE user_info 

SELECT COUNT(DISTINCT id) active_num,TO_DATE(click_time) datestr 

FROM user_clicks 

GROUP BY TO_DATE(click_time);"

